Overview

Dataset info

Number of variables60
Number of observations192609
Missing cells6754992 (58.5%)
Duplicate rows0 (0.0%)
Total size in memory88.2 MiB
Average record size in memory480.0 B

Variables types

Numeric4
Categorical42
Boolean5
Date0
URL0
Text (Unique)1
Rejected0
Unsupported8

Warnings

address has a high cardinality: 151977 distinct values Warning
address has 7682 (4.0%) missing values Missing
attributes has a high cardinality: 93977 distinct values Warning
attributes has 28836 (15.0%) missing values Missing
attributes.AcceptsInsurance is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.AgesAllowed has 192486 (99.9%) missing values Missing
attributes.Alcohol has 144146 (74.8%) missing values Missing
attributes.Ambience has a high cardinality: 383 distinct values Warning
attributes.Ambience has 144530 (75.0%) missing values Missing
attributes.BestNights has a high cardinality: 66 distinct values Warning
attributes.BestNights has 189133 (98.2%) missing values Missing
attributes.BikeParking has 107210 (55.7%) missing values Missing
attributes.BusinessAcceptsBitcoin is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.BusinessAcceptsCreditCards has 79476 (41.3%) missing values Missing
attributes.BusinessParking has 88896 (46.2%) missing values Missing
attributes.ByAppointmentOnly has 145756 (75.7%) missing values Missing
attributes.BYOB has 192581 (> 99.9%) missing values Missing
attributes.BYOBCorkage has 191186 (99.3%) missing values Missing
attributes.Caters has 151981 (78.9%) missing values Missing
attributes.CoatCheck is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.Corkage has 191947 (99.7%) missing values Missing
attributes.DietaryRestrictions has 192550 (> 99.9%) missing values Missing
attributes.DogsAllowed is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.DriveThru is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.GoodForDancing is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.GoodForKids has 126299 (65.6%) missing values Missing
attributes.GoodForMeal has a high cardinality: 77 distinct values Warning
attributes.GoodForMeal has 162683 (84.5%) missing values Missing
attributes.HairSpecializesIn has a high cardinality: 129 distinct values Warning
attributes.HairSpecializesIn has 191603 (99.5%) missing values Missing
attributes.HappyHour is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.HasTV has 144511 (75.0%) missing values Missing
attributes.Music has a high cardinality: 87 distinct values Warning
attributes.Music has 187360 (97.3%) missing values Missing
attributes.NoiseLevel has 148730 (77.2%) missing values Missing
attributes.Open24Hours has 192596 (> 99.9%) missing values Missing
attributes.OutdoorSeating has 137786 (71.5%) missing values Missing
attributes.RestaurantsAttire has 143970 (74.7%) missing values Missing
attributes.RestaurantsCounterService has 192598 (> 99.9%) missing values Missing
attributes.RestaurantsDelivery has 140087 (72.7%) missing values Missing
attributes.RestaurantsGoodForGroups has 137891 (71.6%) missing values Missing
attributes.RestaurantsPriceRange2 has 84430 (43.8%) missing values Missing
attributes.RestaurantsReservations has 140322 (72.9%) missing values Missing
attributes.RestaurantsTableService is an unsupported type, check if it needs cleaning or further analysis Warning
attributes.RestaurantsTakeOut has 130532 (67.8%) missing values Missing
attributes.Smoking has 189111 (98.2%) missing values Missing
attributes.WheelchairAccessible has 172650 (89.6%) missing values Missing
attributes.WiFi has 142545 (74.0%) missing values Missing
categories has a high cardinality: 93386 distinct values Warning
city has a high cardinality: 1204 distinct values Warning
hours has a high cardinality: 51567 distinct values Warning
hours has 44830 (23.3%) missing values Missing
hours.Friday has a high cardinality: 1565 distinct values Warning
hours.Friday has 47435 (24.6%) missing values Missing
hours.Monday has a high cardinality: 1399 distinct values Warning
hours.Monday has 56842 (29.5%) missing values Missing
hours.Saturday has a high cardinality: 1506 distinct values Warning
hours.Saturday has 66748 (34.7%) missing values Missing
hours.Sunday has a high cardinality: 1365 distinct values Warning
hours.Sunday has 101273 (52.6%) missing values Missing
hours.Thursday has a high cardinality: 1525 distinct values Warning
hours.Thursday has 46706 (24.2%) missing values Missing
hours.Tuesday has a high cardinality: 1445 distinct values Warning
hours.Tuesday has 49181 (25.5%) missing values Missing
hours.Wednesday has a high cardinality: 1461 distinct values Warning
hours.Wednesday has 47452 (24.6%) missing values Missing
name has a high cardinality: 145046 distinct values Warning
postal_code has a high cardinality: 17541 distinct values Warning

Variables

address
Categorical

Distinct count151977
Unique (%)78.9%
Missing (%)4.0%
Missing (n)7682
5757 Wayne Newton Blvd
 
96
7014 E Camelback Rd
 
79
3200 Las Vegas Blvd S
 
78
Other values (151973)
184674
(Missing)
 
7682
ValueCountFrequency (%) 
5757 Wayne Newton Blvd 96 < 0.1%
 
7014 E Camelback Rd 79 < 0.1%
 
3200 Las Vegas Blvd S 78 < 0.1%
 
3111 W Chandler Blvd 74 < 0.1%
 
4400 Sharon Rd 70 < 0.1%
 
5000 S Arizona Mills Cir 68 < 0.1%
 
100 City Centre Drive 67 < 0.1%
 
3500 Las Vegas Blvd S 66 < 0.1%
 
3401 Dufferin Street 63 < 0.1%
 
3799 Las Vegas Blvd S 61 < 0.1%
 
Other values (151966) 184205 95.6%
 
(Missing) 7682 4.0%
 
Max length118
Mean length20.30478846
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

attributes
Categorical

Distinct count93977
Unique (%)48.8%
Missing (%)15.0%
Missing (n)28836
{'BusinessAcceptsCreditCards': 'True'}
 
13109
{'ByAppointmentOnly': 'True'}
 
2818
{'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'}
 
2360
Other values (93973)
145486
(Missing)
 
28836
ValueCountFrequency (%) 
{'BusinessAcceptsCreditCards': 'True'} 13109 6.8%
 
{'ByAppointmentOnly': 'True'} 2818 1.5%
 
{'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'} 2360 1.2%
 
{'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'True'} 2279 1.2%
 
{'GoodForKids': 'True'} 2230 1.2%
 
{'ByAppointmentOnly': 'False', 'BusinessAcceptsCreditCards': 'True'} 1564 0.8%
 
{'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False'} 1562 0.8%
 
{'BusinessAcceptsCreditCards': 'False'} 1336 0.7%
 
{'ByAppointmentOnly': 'False'} 1075 0.6%
 
{'GoodForKids': 'False'} 859 0.4%
 
Other values (93966) 134581 69.9%
 
(Missing) 28836 15.0%
 
Max length1609
Mean length283.8301014
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

attributes.AcceptsInsurance
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.AgesAllowed
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)192486
u'21plus'
 
71
u'allages'
 
18
u'19plus'
 
16
Other values (2)
 
18
(Missing)
192486
ValueCountFrequency (%) 
u'21plus' 71 < 0.1%
 
u'allages' 18 < 0.1%
 
u'19plus' 16 < 0.1%
 
u'18plus' 15 < 0.1%
 
None 3 < 0.1%
 
(Missing) 192486 99.9%
 
Max length10
Mean length3.003847172
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

attributes.Alcohol
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)74.8%
Missing (n)144146
u'full_bar'
 
16516
u'none'
 
15714
'none'
 
5954
Other values (4)
 
10279
(Missing)
144146
ValueCountFrequency (%) 
u'full_bar' 16516 8.6%
 
u'none' 15714 8.2%
 
'none' 5954 3.1%
 
u'beer_and_wine' 4669 2.4%
 
'full_bar' 3621 1.9%
 
'beer_and_wine' 1909 1.0%
 
None 80 < 0.1%
 
(Missing) 144146 74.8%
 
Max length16
Mean length4.671147246
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

attributes.Ambience
Categorical

Distinct count383
Unique (%)0.2%
Missing (%)75.0%
Missing (n)144530
{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True}
 
9935
{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False}
 
8982
{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True}
 
5610
Other values (379)
 
23552
(Missing)
144530
ValueCountFrequency (%) 
{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True} 9935 5.2%
 
{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False} 8982 4.7%
 
{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True} 5610 2.9%
 
{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': False} 3856 2.0%
 
{'touristy': False, 'hipster': False, 'romantic': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': False} 3311 1.7%
 
{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': True} 3041 1.6%
 
{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': False} 2949 1.5%
 
{'touristy': False, 'hipster': False, 'romantic': False, 'intimate': False, 'trendy': False, 'upscale': False, 'classy': False, 'casual': True} 1362 0.7%
 
{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': False} 794 0.4%
 
{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': True, 'upscale': False, 'classy': False, 'casual': True} 593 0.3%
 
Other values (372) 7646 4.0%
 
(Missing) 144530 75.0%
 
Max length160
Mean length40.88738844
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.BestNights
Categorical

Distinct count66
Unique (%)< 0.1%
Missing (%)98.2%
Missing (n)189133
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': True, 'sunday': False, 'saturday': True}
 
767
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': True, 'saturday': True}
 
533
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True}
 
231
Other values (62)
 
1945
(Missing)
189133
ValueCountFrequency (%) 
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': True, 'sunday': False, 'saturday': True} 767 0.4%
 
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': True, 'saturday': True} 533 0.3%
 
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} 231 0.1%
 
{'monday': False, 'tuesday': False, 'friday': False, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': False} 230 0.1%
 
{'monday': False, 'tuesday': False, 'friday': False, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} 184 0.1%
 
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': False} 182 0.1%
 
{'monday': False, 'tuesday': False, 'friday': True, 'wednesday': True, 'thursday': False, 'sunday': False, 'saturday': True} 181 0.1%
 
{'monday': True, 'tuesday': False, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} 122 0.1%
 
{'monday': False, 'tuesday': True, 'friday': True, 'wednesday': False, 'thursday': False, 'sunday': False, 'saturday': True} 105 0.1%
 
{'monday': False, 'tuesday': False, 'friday': False, 'wednesday': True, 'thursday': True, 'sunday': False, 'saturday': True} 64 < 0.1%
 
Other values (55) 877 0.5%
 
(Missing) 189133 98.2%
 
Max length127
Mean length5.191091797
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.BikeParking
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)55.7%
Missing (n)107210
True
66331
False
 
18880
None
 
188
(Missing)
107210
ValueCountFrequency (%) 
True 66331 34.4%
 
False 18880 9.8%
 
None 188 0.1%
 
(Missing) 107210 55.7%
 
Max length5
Mean length3.541402531
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.BusinessAcceptsBitcoin
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.BusinessAcceptsCreditCards
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)41.3%
Missing (n)79476
True
106974
False
 
6045
None
 
114
(Missing)
79476
ValueCountFrequency (%) 
True 106974 55.5%
 
False 6045 3.1%
 
None 114 0.1%
 
(Missing) 79476 41.3%
 
Max length5
Mean length3.618756133
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.BusinessParking
Categorical

Distinct count46
Unique (%)< 0.1%
Missing (%)46.2%
Missing (n)88896
{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}
40150
{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}
37037
{'garage': False, 'street': True, 'validated': False, 'lot': False, 'valet': False}
 
14061
Other values (42)
 
12465
(Missing)
88896
ValueCountFrequency (%) 
{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False} 40150 20.8%
 
{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False} 37037 19.2%
 
{'garage': False, 'street': True, 'validated': False, 'lot': False, 'valet': False} 14061 7.3%
 
{'garage': False, 'street': True, 'validated': False, 'lot': True, 'valet': False} 3204 1.7%
 
{'garage': True, 'street': False, 'validated': False, 'lot': False, 'valet': False} 2609 1.4%
 
None 2235 1.2%
 
{'garage': True, 'street': True, 'validated': False, 'lot': False, 'valet': False} 1061 0.6%
 
{'garage': True, 'street': False, 'validated': False, 'lot': False, 'valet': True} 604 0.3%
 
{'garage': True, 'street': False, 'validated': False, 'lot': True, 'valet': False} 397 0.2%
 
{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': True} 339 0.2%
 
Other values (35) 2016 1.0%
 
(Missing) 88896 46.2%
 
Max length84
Mean length45.30923789
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.ByAppointmentOnly
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)75.7%
Missing (n)145756
False
 
24385
True
 
22344
None
 
124
(Missing)
145756
ValueCountFrequency (%) 
False 24385 12.7%
 
True 22344 11.6%
 
None 124 0.1%
 
(Missing) 145756 75.7%
 
Max length5
Mean length3.369858106
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.BYOB
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)192581
False
 
27
True
 
1
(Missing)
192581
ValueCountFrequency (%) 
False 27 < 0.1%
 
True 1 < 0.1%
 
(Missing) 192581 > 99.9%
 

attributes.BYOBCorkage
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)99.3%
Missing (n)191186
'no'
 
757
'yes_free'
 
498
'yes_corkage'
 
145
Other values (4)
 
23
(Missing)
191186
ValueCountFrequency (%) 
'no' 757 0.4%
 
'yes_free' 498 0.3%
 
'yes_corkage' 145 0.1%
 
u'yes_corkage' 13 < 0.1%
 
u'no' 5 < 0.1%
 
None 3 < 0.1%
 
u'yes_free' 2 < 0.1%
 
(Missing) 191186 99.3%
 
Max length14
Mean length3.03045029
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

attributes.Caters
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)78.9%
Missing (n)151981
True
 
20666
False
 
19829
None
 
133
(Missing)
151981
ValueCountFrequency (%) 
True 20666 10.7%
 
False 19829 10.3%
 
None 133 0.1%
 
(Missing) 151981 78.9%
 
Max length5
Mean length3.313884606
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.CoatCheck
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.Corkage
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)99.7%
Missing (n)191947
False
 
524
True
 
138
(Missing)
191947
ValueCountFrequency (%) 
False 524 0.3%
 
True 138 0.1%
 
(Missing) 191947 99.7%
 

attributes.DietaryRestrictions
Categorical

Distinct count12
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)192550
{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}
 
13
{'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}
 
13
{'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}
 
7
Other values (8)
 
26
(Missing)
192550
ValueCountFrequency (%) 
{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} 13 < 0.1%
 
{'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} 13 < 0.1%
 
{'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} 7 < 0.1%
 
None 7 < 0.1%
 
{'dairy-free': False, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False} 6 < 0.1%
 
{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} 4 < 0.1%
 
{'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': True, 'soy-free': False, 'vegetarian': False} 3 < 0.1%
 
{'dairy-free': False, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} 2 < 0.1%
 
{'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True} 2 < 0.1%
 
{'dairy-free': True, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': True, 'vegetarian': True} 1 < 0.1%
 
(Missing) 192550 > 99.9%
 
Max length131
Mean length3.034479178
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.DogsAllowed
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.DriveThru
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.GoodForDancing
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.GoodForKids
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)65.6%
Missing (n)126299
True
53330
False
 
12917
None
 
63
(Missing)
126299
ValueCountFrequency (%) 
True 53330 27.7%
 
False 12917 6.7%
 
None 63 < 0.1%
 
(Missing) 126299 65.6%
 
Max length5
Mean length3.411335919
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.GoodForMeal
Categorical

Distinct count77
Unique (%)< 0.1%
Missing (%)84.5%
Missing (n)162683
{'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': False}
 
8405
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}
 
7711
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': False, 'breakfast': False}
 
3203
Other values (73)
 
10607
(Missing)
162683
ValueCountFrequency (%) 
{'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': False} 8405 4.4%
 
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} 7711 4.0%
 
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': False, 'breakfast': False} 3203 1.7%
 
{'dessert': False, 'latenight': False, 'lunch': False, 'dinner': True, 'brunch': False, 'breakfast': False} 2545 1.3%
 
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': True, 'breakfast': True} 1009 0.5%
 
{'dessert': False, 'latenight': True, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} 744 0.4%
 
{'dessert': True, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False} 635 0.3%
 
{'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'brunch': False, 'breakfast': True} 460 0.2%
 
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': True, 'breakfast': False} 436 0.2%
 
{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': False, 'brunch': True, 'breakfast': False} 397 0.2%
 
Other values (66) 4381 2.3%
 
(Missing) 162683 84.5%
 
Max length108
Mean length18.98549912
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.HairSpecializesIn
Categorical

Distinct count129
Unique (%)0.1%
Missing (%)99.5%
Missing (n)191603
{'straightperms': False, 'coloring': False, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False}
 
135
{'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': True, 'curly': True, 'kids': True, 'perms': True, 'asian': True}
 
113
{'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False}
 
44
Other values (125)
 
714
(Missing)
191603
ValueCountFrequency (%) 
{'straightperms': False, 'coloring': False, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} 135 0.1%
 
{'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': True, 'curly': True, 'kids': True, 'perms': True, 'asian': True} 113 0.1%
 
{'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} 44 < 0.1%
 
{'straightperms': False, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': False, 'kids': False, 'perms': False, 'asian': False} 39 < 0.1%
 
None 31 < 0.1%
 
{'perms': True, 'coloring': True, 'extensions': True, 'curly': True, 'kids': True} 30 < 0.1%
 
{'straightperms': True, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': True, 'kids': True, 'perms': True, 'asian': True} 26 < 0.1%
 
{'perms': False, 'coloring': False, 'extensions': False, 'curly': False, 'kids': False} 26 < 0.1%
 
{'straightperms': False, 'coloring': True, 'extensions': True, 'africanamerican': False, 'curly': True, 'kids': False, 'perms': False, 'asian': False} 24 < 0.1%
 
{'straightperms': False, 'coloring': True, 'extensions': False, 'africanamerican': False, 'curly': True, 'kids': False, 'perms': False, 'asian': False} 22 < 0.1%
 
Other values (118) 516 0.3%
 
(Missing) 191603 99.5%
 
Max length153
Mean length3.690642701
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.HappyHour
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.HasTV
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)75.0%
Missing (n)144511
True
 
25596
False
 
22448
None
 
54
(Missing)
144511
ValueCountFrequency (%) 
True 25596 13.3%
 
False 22448 11.7%
 
None 54 < 0.1%
 
(Missing) 144511 75.0%
 
Max length5
Mean length3.366265335
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.Music
Categorical

Distinct count87
Unique (%)< 0.1%
Missing (%)97.3%
Missing (n)187360
{'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False}
 
2230
{'dj': False, 'background_music': True, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False}
 
524
{'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': True, 'video': False, 'karaoke': False}
 
495
Other values (83)
 
2000
(Missing)
187360
ValueCountFrequency (%) 
{'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} 2230 1.2%
 
{'dj': False, 'background_music': True, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} 524 0.3%
 
{'dj': False, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': True, 'video': False, 'karaoke': False} 495 0.3%
 
{'dj': False} 397 0.2%
 
{'dj': False, 'background_music': True, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} 256 0.1%
 
{'dj': True, 'background_music': False, 'no_music': False, 'jukebox': False, 'live': False, 'video': False, 'karaoke': False} 244 0.1%
 
{'dj': False, 'background_music': False, 'no_music': False, 'jukebox': True, 'live': False, 'video': False, 'karaoke': False} 234 0.1%
 
{} 125 0.1%
 
{'dj': True} 110 0.1%
 
None 68 < 0.1%
 
Other values (76) 566 0.3%
 
(Missing) 187360 97.3%
 
Max length126
Mean length5.826056934
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

attributes.NoiseLevel
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)77.2%
Missing (n)148730
u'average'
 
22681
u'quiet'
 
8080
'average'
 
5620
Other values (6)
 
7498
(Missing)
148730
ValueCountFrequency (%) 
u'average' 22681 11.8%
 
u'quiet' 8080 4.2%
 
'average' 5620 2.9%
 
u'loud' 3509 1.8%
 
u'very_loud' 1614 0.8%
 
'quiet' 1568 0.8%
 
'loud' 574 0.3%
 
'very_loud' 160 0.1%
 
None 73 < 0.1%
 
(Missing) 148730 77.2%
 
Max length12
Mean length4.405936379
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

attributes.Open24Hours
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)192596
False
 
9
True
 
4
(Missing)
192596
ValueCountFrequency (%) 
False 9 < 0.1%
 
True 4 < 0.1%
 
(Missing) 192596 > 99.9%
 

attributes.OutdoorSeating
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)71.5%
Missing (n)137786
False
32813
True
 
21942
None
 
68
(Missing)
137786
ValueCountFrequency (%) 
False 32813 17.0%
 
True 21942 11.4%
 
None 68 < 0.1%
 
(Missing) 137786 71.5%
 
Max length5
Mean length3.454994315
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.RestaurantsAttire
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)74.7%
Missing (n)143970
u'casual'
 
28320
'casual'
 
18753
u'dressy'
 
962
Other values (4)
 
604
(Missing)
143970
ValueCountFrequency (%) 
u'casual' 28320 14.7%
 
'casual' 18753 9.7%
 
u'dressy' 962 0.5%
 
'dressy' 427 0.2%
 
u'formal' 74 < 0.1%
 
'formal' 55 < 0.1%
 
None 48 < 0.1%
 
(Missing) 143970 74.7%
 
Max length9
Mean length4.414051264
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

attributes.RestaurantsCounterService
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)192598
True
 
8
False
 
3
(Missing)
192598
ValueCountFrequency (%) 
True 8 < 0.1%
 
False 3 < 0.1%
 
(Missing) 192598 > 99.9%
 

attributes.RestaurantsDelivery
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)72.7%
Missing (n)140087
False
38559
True
 
13895
None
 
68
(Missing)
140087
ValueCountFrequency (%) 
False 38559 20.0%
 
True 13895 7.2%
 
None 68 < 0.1%
 
(Missing) 140087 72.7%
 
Max length5
Mean length3.472880291
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.RestaurantsGoodForGroups
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)71.6%
Missing (n)137891
True
47422
False
 
7254
None
 
42
(Missing)
137891
ValueCountFrequency (%) 
True 47422 24.6%
 
False 7254 3.8%
 
None 42 < 0.1%
 
(Missing) 137891 71.6%
 
Max length5
Mean length3.321750282
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.RestaurantsPriceRange2
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)43.8%
Missing (n)84430
2
61506
1
33859
3
 
10462
Other values (2)
 
2352
(Missing)
84430
ValueCountFrequency (%) 
2 61506 31.9%
 
1 33859 17.6%
 
3 10462 5.4%
 
4 2255 1.2%
 
None 97 0.1%
 
(Missing) 84430 43.8%
 
Max length4
Mean length1.878209222
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

attributes.RestaurantsReservations
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)72.9%
Missing (n)140322
False
32091
True
 
20147
None
 
49
(Missing)
140322
ValueCountFrequency (%) 
False 32091 16.7%
 
True 20147 10.5%
 
None 49 < 0.1%
 
(Missing) 140322 72.9%
 
Max length5
Mean length3.438079217
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.RestaurantsTableService
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

attributes.RestaurantsTakeOut
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)67.8%
Missing (n)130532
True
56488
False
 
5520
None
 
69
(Missing)
130532
ValueCountFrequency (%) 
True 56488 29.3%
 
False 5520 2.9%
 
None 69 < 0.1%
 
(Missing) 130532 67.8%
 
Max length5
Mean length3.350954524
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.Smoking
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)98.2%
Missing (n)189111
u'no'
 
1767
u'outdoor'
 
1273
u'yes'
 
350
Other values (4)
 
108
(Missing)
189111
ValueCountFrequency (%) 
u'no' 1767 0.9%
 
u'outdoor' 1273 0.7%
 
u'yes' 350 0.2%
 
'no' 61 < 0.1%
 
'outdoor' 23 < 0.1%
 
None 21 < 0.1%
 
'yes' 3 < 0.1%
 
(Missing) 189111 98.2%
 
Max length10
Mean length3.071237585
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

attributes.WheelchairAccessible
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)89.6%
Missing (n)172650
True
 
17190
False
 
2723
None
 
46
(Missing)
172650
ValueCountFrequency (%) 
True 17190 8.9%
 
False 2723 1.4%
 
None 46 < 0.1%
 
(Missing) 172650 89.6%
 
Max length5
Mean length3.117761891
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

attributes.WiFi
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)74.0%
Missing (n)142545
u'free'
 
16355
u'no'
 
14896
'free'
 
9239
Other values (4)
 
9574
(Missing)
142545
ValueCountFrequency (%) 
u'free' 16355 8.5%
 
u'no' 14896 7.7%
 
'free' 9239 4.8%
 
'no' 8864 4.6%
 
u'paid' 414 0.2%
 
'paid' 170 0.1%
 
None 126 0.1%
 
(Missing) 142545 74.0%
 
Max length7
Mean length3.69615127
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

business_id
Categorical, Unique

First 5 values
--1UhMGODdWsrMastO9DZw
--6MefnULPED_I942VcFNA
--7zmmkVg-IMGaXbuVd0SQ
--8LPVSo5i0Oo61X01sV9A
--9QQLMTbFzLJ_oT-ON3Xw
Last 5 values
zzvlwkcNR1CCqOPXwuvz2A
zzwaS0xn1MVEPEf0hNLjew
zzwhN7x37nyjP0ZM8oiHmw
zzwicjPC9g246MK2M1ZFBA
zzzaIBwimxVej4tY6qFOUQ

First 5 values

ValueCountFrequency (%) 
--1UhMGODdWsrMastO9DZw 1 < 0.1%
 
--6MefnULPED_I942VcFNA 1 < 0.1%
 
--7zmmkVg-IMGaXbuVd0SQ 1 < 0.1%
 
--8LPVSo5i0Oo61X01sV9A 1 < 0.1%
 
--9QQLMTbFzLJ_oT-ON3Xw 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
zzzaIBwimxVej4tY6qFOUQ 1 < 0.1%
 
zzwicjPC9g246MK2M1ZFBA 1 < 0.1%
 
zzwhN7x37nyjP0ZM8oiHmw 1 < 0.1%
 
zzwaS0xn1MVEPEf0hNLjew 1 < 0.1%
 
zzvlwkcNR1CCqOPXwuvz2A 1 < 0.1%
 

categories
Categorical

Distinct count93386
Unique (%)48.5%
Missing (%)0.3%
Missing (n)482
Restaurants, Pizza
 
1042
Nail Salons, Beauty & Spas
 
1031
Pizza, Restaurants
 
993
Other values (93382)
189061
ValueCountFrequency (%) 
Restaurants, Pizza 1042 0.5%
 
Nail Salons, Beauty & Spas 1031 0.5%
 
Pizza, Restaurants 993 0.5%
 
Beauty & Spas, Nail Salons 947 0.5%
 
Food, Coffee & Tea 888 0.5%
 
Mexican, Restaurants 885 0.5%
 
Coffee & Tea, Food 865 0.4%
 
Restaurants, Mexican 853 0.4%
 
Chinese, Restaurants 840 0.4%
 
Hair Salons, Beauty & Spas 831 0.4%
 
Other values (93375) 182952 95.0%
 
Max length550
Mean length55.02609432
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

city
Categorical

Distinct count1204
Unique (%)0.6%
Missing (%)< 0.1%
Missing (n)1
Las Vegas
29370
Toronto
 
18906
Phoenix
 
18766
Other values (1200)
125566
ValueCountFrequency (%) 
Las Vegas 29370 15.2%
 
Toronto 18906 9.8%
 
Phoenix 18766 9.7%
 
Charlotte 9509 4.9%
 
Scottsdale 8837 4.6%
 
Calgary 7736 4.0%
 
Pittsburgh 7017 3.6%
 
Montréal 6449 3.3%
 
Mesa 6080 3.2%
 
Henderson 4892 2.5%
 
Other values (1193) 75046 39.0%
 
Max length50
Mean length8.309699962
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

hours
Categorical

Distinct count51567
Unique (%)26.8%
Missing (%)23.3%
Missing (n)44830
{'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'}
 
7818
{'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'}
 
3006
{'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0'}
 
2608
Other values (51563)
134347
(Missing)
44830
ValueCountFrequency (%) 
{'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'} 7818 4.1%
 
{'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'} 3006 1.6%
 
{'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0'} 2608 1.4%
 
{'Monday': '10:0-21:0', 'Tuesday': '10:0-21:0', 'Wednesday': '10:0-21:0', 'Thursday': '10:0-21:0', 'Friday': '10:0-21:0', 'Saturday': '10:0-21:0', 'Sunday': '11:0-18:0'} 985 0.5%
 
{'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0', 'Wednesday': '11:0-22:0', 'Thursday': '11:0-22:0', 'Friday': '11:0-22:0', 'Saturday': '11:0-22:0', 'Sunday': '11:0-22:0'} 892 0.5%
 
{'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0', 'Wednesday': '11:0-22:0', 'Thursday': '11:0-22:0', 'Friday': '11:0-23:0', 'Saturday': '11:0-23:0', 'Sunday': '11:0-22:0'} 816 0.4%
 
{'Monday': '8:30-17:0', 'Tuesday': '8:30-17:0', 'Wednesday': '8:30-17:0', 'Thursday': '8:30-17:0', 'Friday': '8:30-17:0'} 568 0.3%
 
{'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0', 'Wednesday': '11:0-21:0', 'Thursday': '11:0-21:0', 'Friday': '11:0-21:0', 'Saturday': '11:0-21:0', 'Sunday': '11:0-21:0'} 554 0.3%
 
{'Monday': '9:0-17:0', 'Tuesday': '9:0-17:0', 'Wednesday': '9:0-17:0', 'Thursday': '9:0-17:0', 'Friday': '9:0-17:0', 'Saturday': '9:0-17:0'} 539 0.3%
 
{'Monday': '10:0-22:0', 'Tuesday': '10:0-22:0', 'Wednesday': '10:0-22:0', 'Thursday': '10:0-22:0', 'Friday': '10:0-22:0', 'Saturday': '10:0-22:0', 'Sunday': '10:0-22:0'} 523 0.3%
 
Other values (51556) 129470 67.2%
 
(Missing) 44830 23.3%
 
Max length183
Mean length115.4857613
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

hours.Friday
Categorical

Distinct count1565
Unique (%)0.8%
Missing (%)24.6%
Missing (n)47435
0:0-0:0
 
8098
9:0-17:0
 
6584
8:0-17:0
 
6124
Other values (1561)
124368
(Missing)
47435
ValueCountFrequency (%) 
0:0-0:0 8098 4.2%
 
9:0-17:0 6584 3.4%
 
8:0-17:0 6124 3.2%
 
9:0-18:0 5866 3.0%
 
10:0-21:0 4635 2.4%
 
11:0-22:0 3868 2.0%
 
10:0-18:0 3802 2.0%
 
11:0-23:0 3412 1.8%
 
10:0-19:0 3225 1.7%
 
8:0-18:0 3212 1.7%
 
Other values (1554) 96348 50.0%
 
(Missing) 47435 24.6%
 
Max length11
Mean length7.147770873
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Monday
Categorical

Distinct count1399
Unique (%)0.7%
Missing (%)29.5%
Missing (n)56842
0:0-0:0
20865
8:0-17:0
 
5969
9:0-17:0
 
5881
Other values (1395)
103052
(Missing)
56842
ValueCountFrequency (%) 
0:0-0:0 20865 10.8%
 
8:0-17:0 5969 3.1%
 
9:0-17:0 5881 3.1%
 
9:0-18:0 4594 2.4%
 
11:0-22:0 4274 2.2%
 
10:0-21:0 4202 2.2%
 
9:0-21:0 3115 1.6%
 
11:0-21:0 3014 1.6%
 
10:0-18:0 2975 1.5%
 
8:0-18:0 2766 1.4%
 
Other values (1388) 78112 40.6%
 
(Missing) 56842 29.5%
 
Max length11
Mean length6.77708726
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Saturday
Categorical

Distinct count1506
Unique (%)0.8%
Missing (%)34.7%
Missing (n)66748
0:0-0:0
 
8128
9:0-17:0
 
4774
9:0-18:0
 
4257
Other values (1502)
108702
(Missing)
66748
ValueCountFrequency (%) 
0:0-0:0 8128 4.2%
 
9:0-17:0 4774 2.5%
 
9:0-18:0 4257 2.2%
 
10:0-18:0 3869 2.0%
 
10:0-17:0 3573 1.9%
 
10:0-21:0 3364 1.7%
 
11:0-22:0 3341 1.7%
 
11:0-23:0 2961 1.5%
 
8:0-17:0 2305 1.2%
 
9:0-21:0 2284 1.2%
 
Other values (1495) 87005 45.2%
 
(Missing) 66748 34.7%
 
Max length11
Mean length6.579879445
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Sunday
Categorical

Distinct count1365
Unique (%)0.7%
Missing (%)52.6%
Missing (n)101273
0:0-0:0
 
7989
11:0-18:0
 
3252
11:0-22:0
 
3110
Other values (1361)
76985
(Missing)
101273
ValueCountFrequency (%) 
0:0-0:0 7989 4.1%
 
11:0-18:0 3252 1.7%
 
11:0-22:0 3110 1.6%
 
10:0-17:0 2710 1.4%
 
10:0-18:0 2705 1.4%
 
12:0-17:0 2486 1.3%
 
11:0-17:0 2388 1.2%
 
11:0-21:0 2379 1.2%
 
9:0-17:0 1915 1.0%
 
12:0-18:0 1748 0.9%
 
Other values (1354) 60654 31.5%
 
(Missing) 101273 52.6%
 
Max length11
Mean length5.645063315
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Thursday
Categorical

Distinct count1525
Unique (%)0.8%
Missing (%)24.2%
Missing (n)46706
0:0-0:0
 
8086
8:0-17:0
 
6689
9:0-17:0
 
6407
Other values (1521)
124721
(Missing)
46706
ValueCountFrequency (%) 
0:0-0:0 8086 4.2%
 
8:0-17:0 6689 3.5%
 
9:0-17:0 6407 3.3%
 
9:0-18:0 5053 2.6%
 
10:0-21:0 4973 2.6%
 
11:0-22:0 4868 2.5%
 
11:0-21:0 3843 2.0%
 
10:0-20:0 3786 2.0%
 
9:0-21:0 3702 1.9%
 
10:0-19:0 3646 1.9%
 
Other values (1514) 94850 49.2%
 
(Missing) 46706 24.2%
 
Max length11
Mean length7.195707366
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Tuesday
Categorical

Distinct count1445
Unique (%)0.8%
Missing (%)25.5%
Missing (n)49181
0:0-0:0
 
8078
8:0-17:0
 
6739
9:0-17:0
 
6520
Other values (1441)
122091
(Missing)
49181
ValueCountFrequency (%) 
0:0-0:0 8078 4.2%
 
8:0-17:0 6739 3.5%
 
9:0-17:0 6520 3.4%
 
9:0-18:0 5377 2.8%
 
11:0-22:0 4884 2.5%
 
10:0-21:0 4587 2.4%
 
10:0-18:0 4020 2.1%
 
11:0-21:0 3766 2.0%
 
10:0-19:0 3606 1.9%
 
9:0-21:0 3478 1.8%
 
Other values (1434) 92373 48.0%
 
(Missing) 49181 25.5%
 
Max length11
Mean length7.123265268
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

hours.Wednesday
Categorical

Distinct count1461
Unique (%)0.8%
Missing (%)24.6%
Missing (n)47452
0:0-0:0
 
8075
8:0-17:0
 
6727
9:0-17:0
 
6521
Other values (1457)
123834
(Missing)
47452
ValueCountFrequency (%) 
0:0-0:0 8075 4.2%
 
8:0-17:0 6727 3.5%
 
9:0-17:0 6521 3.4%
 
9:0-18:0 5491 2.9%
 
11:0-22:0 4965 2.6%
 
10:0-21:0 4660 2.4%
 
10:0-18:0 4045 2.1%
 
11:0-21:0 3823 2.0%
 
10:0-19:0 3512 1.8%
 
9:0-21:0 3422 1.8%
 
Other values (1450) 93916 48.8%
 
(Missing) 47452 24.6%
 
Max length11
Mean length7.176076923
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

is_open
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
158525
0
34084
ValueCountFrequency (%) 
1 158525 82.3%
 
0 34084 17.7%
 

latitude
Numeric

Distinct count155162
Unique (%)80.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean38.54180263
Minimum33.204642
Maximum51.29994269
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum33.204642
5-th percentile33.3649772
Q133.637408
Median36.144815
Q343.602989
95-th percentile45.5364432
Maximum51.29994269
Range18.09530069
Interquartile range9.965581

Descriptive statistics

Standard deviation4.941963503
Coef of variation0.1282234656
Kurtosis-0.5181507852
Mean38.54180263
MAD4.43654809
Skewness0.6841439291
Sum7423498.063
Variance24.42300326
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[33.204642 33.21729415 33.22045535 33.22355885 33.22383905 ... 51.27231085 51.2853456 51.29124242 51.29349075 51.29994269], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
36.1697096 167 0.1%
 
36.128561 125 0.1%
 
33.4483771 116 0.1%
 
36.175 91 < 0.1%
 
33.4986286 90 < 0.1%
 
43.653226 88 < 0.1%
 
36.18 72 < 0.1%
 
33.3260297 69 < 0.1%
 
33.4499672 67 < 0.1%
 
36.0357492 65 < 0.1%
 
Other values (155152) 191659 99.5%
 

Minimum 5 values

ValueCountFrequency (%) 
33.204642 1 < 0.1%
 
33.20486311 1 < 0.1%
 
33.20530832 1 < 0.1%
 
33.2057187 2 < 0.1%
 
33.205767 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
51.29994269 1 < 0.1%
 
51.2978143 1 < 0.1%
 
51.2966203 1 < 0.1%
 
51.2965919 1 < 0.1%
 
51.2963563 1 < 0.1%
 

longitude
Numeric

Distinct count150404
Unique (%)78.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-97.59478532
Minimum-115.4934712
Maximum-72.9119819
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-115.4934712
5-th percentile-115.2352134
Q1-112.2746773
Median-111.7593235
Q3-79.9836143
95-th percentile-79.02056666
Maximum-72.9119819
Range42.58148934
Interquartile range32.291063

Descriptive statistics

Standard deviation16.69772482
Coef of variation-0.1710923874
Kurtosis-1.896632781
Mean-97.59478532
MAD16.48162302
Skewness0.1398988358
Sum-18797634
Variance278.814014
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-115.49347124 -115.45554859 -115.44866785 -115.3670288 -115.3660614 ... -73.25245416 -73.250653 -73.14703265 -72.98966624 -72.9119819 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-115.1236952 168 0.1%
 
-111.9403254 167 0.1%
 
-115.1711298 158 0.1%
 
-111.8210866 157 0.1%
 
-115.2244853 156 0.1%
 
-115.1533426 118 0.1%
 
-112.0740373 116 0.1%
 
-115.2659777 113 0.1%
 
-115.2778317 103 0.1%
 
-112.0118669 93 < 0.1%
 
Other values (150394) 191260 99.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-115.4934712 1 < 0.1%
 
-115.4775186 1 < 0.1%
 
-115.47369 1 < 0.1%
 
-115.4562899 1 < 0.1%
 
-115.4548073 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
-72.9119819 1 < 0.1%
 
-72.9342959 1 < 0.1%
 
-72.94493768 1 < 0.1%
 
-72.94505 1 < 0.1%
 
-72.9453515 1 < 0.1%
 

name
Categorical

Distinct count145046
Unique (%)75.3%
Missing (%)0.0%
Missing (n)0
Starbucks
 
1066
McDonald's
 
806
Subway
 
768
Other values (145043)
189969
ValueCountFrequency (%) 
Starbucks 1066 0.6%
 
McDonald's 806 0.4%
 
Subway 768 0.4%
 
Tim Hortons 333 0.2%
 
Pizza Hut 320 0.2%
 
Taco Bell 313 0.2%
 
Burger King 302 0.2%
 
Walgreens 301 0.2%
 
Wendy's 294 0.2%
 
The UPS Store 279 0.1%
 
Other values (145036) 187827 97.5%
 
Max length64
Mean length18.72079186
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

postal_code
Categorical

Distinct count17541
Unique (%)9.1%
Missing (%)0.3%
Missing (n)659
89109
 
3195
85251
 
2150
85260
 
1893
Other values (17537)
184712
ValueCountFrequency (%) 
89109 3195 1.7%
 
85251 2150 1.1%
 
85260 1893 1.0%
 
85281 1891 1.0%
 
89119 1866 1.0%
 
89102 1650 0.9%
 
85308 1503 0.8%
 
89103 1481 0.8%
 
85032 1435 0.7%
 
85016 1430 0.7%
 
Other values (17530) 173456 90.1%
 
Max length8
Mean length5.478549808
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

review_count
Numeric

Distinct count1184
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean33.53896235
Minimum3
Maximum8348
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3
5-th percentile3
Q14
Median9
Q325
95-th percentile130
Maximum8348
Range8345
Interquartile range21

Descriptive statistics

Standard deviation110.1352244
Coef of variation3.2837994
Kurtosis778.5035282
Mean33.53896235
MAD38.55879699
Skewness19.60408148
Sum6459906
Variance12129.76766
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[3.0000e+00 3.5000e+00 4.5000e+00 5.5000e+00 6.5000e+00 ... 1.2050e+03 1.6800e+03 2.6135e+03 4.3610e+03 8.3480e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 33940 17.6%
 
4 18534 9.6%
 
5 13615 7.1%
 
6 10951 5.7%
 
7 8911 4.6%
 
8 7517 3.9%
 
9 6548 3.4%
 
10 5436 2.8%
 
11 4783 2.5%
 
12 4261 2.2%
 
Other values (1174) 78113 40.6%
 

Minimum 5 values

ValueCountFrequency (%) 
3 33940 17.6%
 
4 18534 9.6%
 
5 13615 7.1%
 
6 10951 5.7%
 
7 8911 4.6%
 

Maximum 5 values

ValueCountFrequency (%) 
8348 1 < 0.1%
 
8339 1 < 0.1%
 
6708 1 < 0.1%
 
5763 1 < 0.1%
 
5484 1 < 0.1%
 

stars
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.58562684
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1.5
Q13
Median3.5
Q34.5
95-th percentile5
Maximum5
Range4
Interquartile range1.5

Descriptive statistics

Standard deviation1.018458284
Coef of variation0.2840391176
Kurtosis-0.3626834354
Mean3.58562684
MAD0.828370875
Skewness-0.4965602926
Sum690624
Variance1.037257276
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
4 35969 18.7%
 
3.5 35008 18.2%
 
5 28216 14.6%
 
4.5 27301 14.2%
 
3 25996 13.5%
 
2.5 18843 9.8%
 
2 11426 5.9%
 
1.5 4976 2.6%
 
1 4874 2.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 4874 2.5%
 
1.5 4976 2.6%
 
2 11426 5.9%
 
2.5 18843 9.8%
 
3 25996 13.5%
 

Maximum 5 values

ValueCountFrequency (%) 
5 28216 14.6%
 
4.5 27301 14.2%
 
4 35969 18.7%
 
3.5 35008 18.2%
 
3 25996 13.5%
 

state
Categorical

Distinct count36
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
AZ
56686
NV
36312
ON
33412
Other values (33)
66199
ValueCountFrequency (%) 
AZ 56686 29.4%
 
NV 36312 18.9%
 
ON 33412 17.3%
 
NC 14720 7.6%
 
OH 14697 7.6%
 
PA 11216 5.8%
 
QC 9219 4.8%
 
AB 8012 4.2%
 
WI 5154 2.7%
 
IL 1932 1.0%
 
Other values (26) 1249 0.6%
 
Max length3
Mean length2.000057111
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Correlations

Missing values

Sample

First rows

addressattributesattributes.AcceptsInsuranceattributes.AgesAllowedattributes.Alcoholattributes.Ambienceattributes.BestNightsattributes.BikeParkingattributes.BusinessAcceptsBitcoinattributes.BusinessAcceptsCreditCardsattributes.BusinessParkingattributes.ByAppointmentOnlyattributes.BYOBattributes.BYOBCorkageattributes.Catersattributes.CoatCheckattributes.Corkageattributes.DietaryRestrictionsattributes.DogsAllowedattributes.DriveThruattributes.GoodForDancingattributes.GoodForKidsattributes.GoodForMealattributes.HairSpecializesInattributes.HappyHourattributes.HasTVattributes.Musicattributes.NoiseLevelattributes.Open24Hoursattributes.OutdoorSeatingattributes.RestaurantsAttireattributes.RestaurantsCounterServiceattributes.RestaurantsDeliveryattributes.RestaurantsGoodForGroupsattributes.RestaurantsPriceRange2attributes.RestaurantsReservationsattributes.RestaurantsTableServiceattributes.RestaurantsTakeOutattributes.Smokingattributes.WheelchairAccessibleattributes.WiFibusiness_idcategoriescityhourshours.Fridayhours.Mondayhours.Saturdayhours.Sundayhours.Thursdayhours.Tuesdayhours.Wednesdayis_openlatitudelongitudenamepostal_codereview_countstarsstate
02818 E Camino Acequia Drive{'GoodForKids': 'False'}NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1SWheh84yJXfytovILXOAQGolf, Active LifePhoenixNaNNaNNaNNaNNaNNaNNaNNaN033.522143-112.018481Arizona Biltmore Golf Club8501653.0AZ
130 Eglinton Avenue W{'RestaurantsReservations': 'True', 'GoodForMeal': "{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}", 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'Caters': 'True', 'NoiseLevel': "u'loud'", 'RestaurantsTableService': 'True', 'RestaurantsTakeOut': 'True', 'RestaurantsPriceRange2': '2', 'OutdoorSeating': 'False', 'BikeParking': 'False', 'Ambience': "{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True}", 'HasTV': 'False', 'WiFi': "u'no'", 'GoodForKids': 'True', 'Alcohol': "u'full_bar'", 'RestaurantsAttire': "u'casual'", 'RestaurantsGoodForGroups': 'True', 'RestaurantsDelivery': 'False'}NaNNaNu'full_bar'{'romantic': False, 'intimate': False, 'classy': False, 'hipster': False, 'divey': False, 'touristy': False, 'trendy': False, 'upscale': False, 'casual': True}NaNFalseNaNNaN{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}NaNNaNNaNTrueNaNNaNNaNNaNNaNNaNTrue{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}NaNNaNFalseNaNu'loud'NaNFalseu'casual'NaNFalseTrue2TrueTrueTrueNaNNaNu'no'QXAEGFB4oINsVuTFxEYKFQSpecialty Food, Restaurants, Dim Sum, Imported Food, Food, Chinese, Ethnic Food, SeafoodMississauga{'Monday': '9:0-0:0', 'Tuesday': '9:0-0:0', 'Wednesday': '9:0-0:0', 'Thursday': '9:0-0:0', 'Friday': '9:0-1:0', 'Saturday': '9:0-1:0', 'Sunday': '9:0-0:0'}9:0-1:09:0-0:09:0-1:09:0-0:09:0-0:09:0-0:09:0-0:0143.605499-79.652289Emerald Chinese RestaurantL5R 3E71282.5ON
210110 Johnston Rd, Ste 15{'GoodForKids': 'True', 'NoiseLevel': "u'average'", 'RestaurantsDelivery': 'False', 'GoodForMeal': "{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}", 'Alcohol': "u'beer_and_wine'", 'Caters': 'False', 'WiFi': "u'no'", 'RestaurantsTakeOut': 'True', 'BusinessAcceptsCreditCards': 'True', 'Ambience': "{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True}", 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'RestaurantsTableService': 'True', 'RestaurantsGoodForGroups': 'True', 'OutdoorSeating': 'False', 'HasTV': 'True', 'BikeParking': 'True', 'RestaurantsReservations': 'True', 'RestaurantsPriceRange2': '2', 'RestaurantsAttire': "'casual'"}NaNNaNu'beer_and_wine'{'romantic': False, 'intimate': False, 'touristy': False, 'hipster': False, 'divey': False, 'classy': False, 'trendy': False, 'upscale': False, 'casual': True}NaNTrueNaNTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}NaNNaNNaNFalseNaNNaNNaNNaNNaNNaNTrue{'dessert': False, 'latenight': False, 'lunch': True, 'dinner': True, 'brunch': False, 'breakfast': False}NaNNaNTrueNaNu'average'NaNFalse'casual'NaNFalseTrue2TrueTrueTrueNaNNaNu'no'gnKjwL_1w79qoiV3IC_xQQSushi Bars, Restaurants, JapaneseCharlotte{'Monday': '17:30-21:30', 'Wednesday': '17:30-21:30', 'Thursday': '17:30-21:30', 'Friday': '17:30-22:0', 'Saturday': '17:30-22:0', 'Sunday': '17:30-21:0'}17:30-22:017:30-21:3017:30-22:017:30-21:017:30-21:30NaN17:30-21:30135.092564-80.859132Musashi Japanese Restaurant282101704.0NC
315655 W Roosevelt St, Ste 237NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNxvX2CttrVhyG2z1dFg_0xwInsurance, Financial ServicesGoodyear{'Monday': '8:0-17:0', 'Tuesday': '8:0-17:0', 'Wednesday': '8:0-17:0', 'Thursday': '8:0-17:0', 'Friday': '8:0-17:0'}8:0-17:08:0-17:0NaNNaN8:0-17:08:0-17:08:0-17:0133.455613-112.395596Farmers Insurance - Paul Lorenz8533835.0AZ
44209 Stuart Andrew Blvd, Ste F{'BusinessAcceptsBitcoin': 'False', 'ByAppointmentOnly': 'True', 'BusinessAcceptsCreditCards': 'True'}NaNNaNNaNNaNNaNNaNFalseTrueNaNTrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNHhyxOkGAM07SRYtlQ4wMFQPlumbing, Shopping, Local Services, Home Services, Kitchen & Bath, Home & Garden, Water Heater Installation/RepairCharlotte{'Monday': '7:0-23:0', 'Tuesday': '7:0-23:0', 'Wednesday': '7:0-23:0', 'Thursday': '7:0-23:0', 'Friday': '7:0-23:0', 'Saturday': '7:0-23:0', 'Sunday': '7:0-23:0'}7:0-23:07:0-23:07:0-23:07:0-23:07:0-23:07:0-23:07:0-23:0135.190012-80.887223Queen City Plumbing2821744.0NC
5Credit Valley Town Plaza, F2 - 6045 Creditview Rd{'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}", 'RestaurantsPriceRange2': '2'}NaNNaNNaNNaNNaNNaNNaNNaN{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaN68dUKd8_8liJ7in4aWOSEAShipping Centers, Couriers & Delivery Services, Local Services, Printing ServicesMississauga{'Monday': '9:0-19:0', 'Tuesday': '9:0-20:0', 'Wednesday': '9:0-20:0', 'Thursday': '9:0-20:0', 'Friday': '9:0-19:0', 'Saturday': '10:0-16:0'}9:0-19:09:0-19:010:0-16:0NaN9:0-20:09:0-20:09:0-20:0143.599475-79.711584The UPS StoreL5V 0B132.5ON
620 Douglas Woods Drive Southeast{'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'ByAppointmentOnly': 'True'}NaNNaNNaNNaNNaNNaNNaNNaN{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}TrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaN5JucpCfHZltJh5r1JabjDgBeauty & Spas, Hair SalonsCalgaryNaNNaNNaNNaNNaNNaNNaNNaN150.943646-114.001828Edgeworxx StudioT2Z 1K473.5AB
74545 E Tropicana Rd Ste 8, Tropicana{'RestaurantsPriceRange2': '3', 'GoodForKids': 'True', 'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False', 'BikeParking': 'False'}NaNNaNNaNNaNNaNFalseNaNTrueNaNFalseNaNNaNNaNNaNNaNNaNNaNNaNNaNTrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN3NaNNaNNaNNaNNaNNaNgbQN7vr_caG_A1ugSmGhWgHair Salons, Hair Stylists, Barbers, Men's Hair Salons, Cosmetics & Beauty Supply, Shopping, Beauty & SpasLas Vegas{'Monday': '10:0-19:0', 'Tuesday': '10:0-19:0', 'Wednesday': '10:0-19:0', 'Thursday': '10:0-19:0', 'Friday': '10:0-19:0', 'Saturday': '10:0-19:0', 'Sunday': '10:0-18:0'}10:0-19:010:0-19:010:0-19:010:0-18:010:0-19:010:0-19:010:0-19:0136.099872-115.074574Supercuts8912133.5NV
85940 W Union Hills Dr{'RestaurantsPriceRange2': '2', 'ByAppointmentOnly': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'BusinessAcceptsCreditCards': 'True', 'BikeParking': 'False'}NaNNaNNaNNaNNaNFalseNaNTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}TrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaNY6iyemLX_oylRpnr38vgMANail Salons, Beauty & Spas, Day SpasGlendale{'Tuesday': '12:0-18:0', 'Wednesday': '10:0-18:0', 'Thursday': '12:0-18:0', 'Friday': '10:0-17:0', 'Saturday': '10:0-14:0'}10:0-17:0NaN10:0-14:0NaN12:0-18:012:0-18:010:0-18:0033.654815-112.188568Vita Bella Fine Day Spa8530885.0AZ
921689 Lorain Rd{'ByAppointmentOnly': 'False', 'BusinessAcceptsCreditCards': 'True', 'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'AcceptsInsurance': 'False'}FalseNaNNaNNaNNaNNaNNaNTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}FalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaN4GBVPIYRvzGh4K4TkRQ_rwBeauty & Spas, Nail Salons, Day Spas, MassageFairview Park{'Tuesday': '9:0-21:0', 'Wednesday': '9:0-21:0', 'Thursday': '9:0-21:0', 'Friday': '9:0-19:0', 'Saturday': '9:0-16:0'}9:0-19:0NaN9:0-16:0NaN9:0-21:09:0-21:09:0-21:0141.440825-81.854097Options Salon & Spa4412684.5OH

Last rows

addressattributesattributes.AcceptsInsuranceattributes.AgesAllowedattributes.Alcoholattributes.Ambienceattributes.BestNightsattributes.BikeParkingattributes.BusinessAcceptsBitcoinattributes.BusinessAcceptsCreditCardsattributes.BusinessParkingattributes.ByAppointmentOnlyattributes.BYOBattributes.BYOBCorkageattributes.Catersattributes.CoatCheckattributes.Corkageattributes.DietaryRestrictionsattributes.DogsAllowedattributes.DriveThruattributes.GoodForDancingattributes.GoodForKidsattributes.GoodForMealattributes.HairSpecializesInattributes.HappyHourattributes.HasTVattributes.Musicattributes.NoiseLevelattributes.Open24Hoursattributes.OutdoorSeatingattributes.RestaurantsAttireattributes.RestaurantsCounterServiceattributes.RestaurantsDeliveryattributes.RestaurantsGoodForGroupsattributes.RestaurantsPriceRange2attributes.RestaurantsReservationsattributes.RestaurantsTableServiceattributes.RestaurantsTakeOutattributes.Smokingattributes.WheelchairAccessibleattributes.WiFibusiness_idcategoriescityhourshours.Fridayhours.Mondayhours.Saturdayhours.Sundayhours.Thursdayhours.Tuesdayhours.Wednesdayis_openlatitudelongitudenamepostal_codereview_countstarsstate
192599343 N Gilbert Rd{'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'True'}NaNNaNNaNNaNNaNNaNNaNTrueNaNTrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNABjONdA5Fw8XBOM65tmW4wPlumbing, Water Heater Installation/Repair, Professional Services, Home Services, ContractorsGilbert{'Monday': '7:0-17:0', 'Tuesday': '7:0-17:30', 'Wednesday': '7:0-17:30', 'Thursday': '7:0-17:30', 'Friday': '7:0-17:30', 'Saturday': '8:0-17:0'}7:0-17:307:0-17:08:0-17:0NaN7:0-17:307:0-17:307:0-17:30133.356540-111.789367Phend Plumbing & Rooter85234475.0AZ
192600NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNZidLd2a1uJCMfIhLylX5wwPet Training, Professional Services, Pet Services, PetsPhoenix{'Monday': '8:0-19:30', 'Tuesday': '8:0-19:30', 'Wednesday': '8:0-19:30', 'Thursday': '8:0-19:30', 'Friday': '8:0-19:30', 'Saturday': '8:0-19:30', 'Sunday': '8:0-15:0'}8:0-19:308:0-19:308:0-19:308:0-15:08:0-19:308:0-19:308:0-19:30133.347160-111.975380Team Canine85076194.5AZ
1926015350 E Marriott Dr{'BusinessAcceptsBitcoin': 'False', 'GoodForKids': 'True', 'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': True}", 'WheelchairAccessible': 'True', 'RestaurantsPriceRange2': '3', 'WiFi': "u'paid'", 'DogsAllowed': 'False'}NaNNaNNaNNaNNaNNaNFalseTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': True}FalseNaNNaNNaNNaNNaNNaNFalseNaNNaNTrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN3NaNNaNNaNNaNTrueu'paid'jJoPLIhCjkGXy59I4Jl6zwGolf, Hotels, Day Spas, Hotels & Travel, Event Planning & Services, Beauty & Spas, Active Life, Venues & Event Spaces, ResortsPhoenix{'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'}0:0-0:00:0-0:00:0-0:00:0-0:00:0-0:00:0-0:00:0-0:0133.683910-111.966235JW Marriott Phoenix Desert Ridge Resort & Spa850544414.0AZ
1926022179 S Green Rd{'RestaurantsPriceRange2': '2', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'BusinessAcceptsCreditCards': 'True', 'Caters': 'False', 'BikeParking': 'True'}NaNNaNNaNNaNNaNTrueNaNTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}NaNNaNNaNFalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaNgo-_xdHHSufchOeZ3kkC8wFood, Beer, Wine & SpiritsUniversity Heights{'Monday': '11:30-21:0', 'Tuesday': '9:0-21:0', 'Wednesday': '9:0-21:0', 'Thursday': '9:0-21:0', 'Friday': '9:0-23:0', 'Saturday': '11:0-23:0', 'Sunday': '13:0-18:0'}9:0-23:011:30-21:011:0-23:013:0-18:09:0-21:09:0-21:09:0-21:0041.500621-81.518241Cedar Green Wine & Cheese44121123.0OH
1926031911 N Cleveland-Massillon Rd{'OutdoorSeating': 'True', 'BikeParking': 'True', 'WiFi': "u'free'", 'RestaurantsPriceRange2': '3', 'Caters': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'RestaurantsDelivery': 'False', 'RestaurantsTakeOut': 'True', 'RestaurantsReservations': 'True', 'RestaurantsAttire': "u'casual'", 'BusinessAcceptsCreditCards': 'True', 'BusinessAcceptsBitcoin': 'False', 'RestaurantsGoodForGroups': 'True', 'Alcohol': "u'full_bar'", 'HasTV': 'True', 'NoiseLevel': "u'average'", 'GoodForKids': 'False', 'Ambience': "{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': True, 'classy': False, 'casual': False}"}NaNNaNu'full_bar'{'touristy': False, 'hipster': False, 'romantic': False, 'divey': False, 'intimate': False, 'trendy': False, 'upscale': True, 'classy': False, 'casual': False}NaNTrueFalseTrue{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}NaNNaNNaNTrueNaNNaNNaNNaNNaNNaNFalseNaNNaNNaNTrueNaNu'average'NaNTrueu'casual'NaNFalseTrue3TrueNaNTrueNaNNaNu'free'p1eUTUB_5hf1enoKYBV3DARestaurants, ItalianBath{'Monday': '0:0-0:0', 'Tuesday': '17:0-22:0', 'Wednesday': '17:0-22:0', 'Thursday': '17:0-22:0', 'Friday': '17:0-22:0', 'Saturday': '17:0-22:0', 'Sunday': '17:0-22:0'}17:0-22:00:0-0:017:0-22:017:0-22:017:0-22:017:0-22:017:0-22:0141.187547-81.635791Ken Stewart's Tre Belle44210393.5OH
192604NaN{'BusinessAcceptsCreditCards': 'True'}NaNNaNNaNNaNNaNNaNNaNTrueNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNnqb4kWcOwp8bFxzfvaDpZQWater Purification Services, Water Heater Installation/Repair, Home Services, PlumbingNorth Las Vegas{'Monday': '0:0-0:0', 'Tuesday': '0:0-0:0', 'Wednesday': '0:0-0:0', 'Thursday': '0:0-0:0', 'Friday': '0:0-0:0', 'Saturday': '0:0-0:0', 'Sunday': '0:0-0:0'}0:0-0:00:0-0:00:0-0:00:0-0:00:0-0:00:0-0:00:0-0:0136.213732-115.177059Sanderson Plumbing8903295.0NV
19260517440 Yonge Street{'RestaurantsPriceRange2': '2', 'BikeParking': 'True', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}"}NaNNaNNaNNaNNaNTrueNaNNaN{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2NaNNaNNaNNaNNaNNaNvY2nLU5K20Pee-FdG0br1gBooks, Mags, Music & Video, ShoppingNewmarketNaNNaNNaNNaNNaNNaNNaNNaN144.052658-79.481850ChaptersL3Y 6Y934.5ON
19260621230 N 22nd St{'BusinessAcceptsCreditCards': 'True', 'ByAppointmentOnly': 'False'}NaNNaNNaNNaNNaNNaNNaNTrueNaNFalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNMiEyUDKTjeci5TMfxVZPpgHome Services, Contractors, Landscaping, Masonry/Concrete, Landscape ArchitectsPhoenix{'Monday': '7:0-15:0', 'Tuesday': '7:0-15:0', 'Wednesday': '7:0-15:0', 'Thursday': '7:0-15:0', 'Friday': '7:0-15:0'}7:0-15:07:0-15:0NaNNaN7:0-15:07:0-15:07:0-15:0133.679992-112.035569Phoenix Pavers85024144.5AZ
1926074406 E Main St{'RestaurantsPriceRange2': '1', 'BusinessAcceptsCreditCards': 'False', 'BusinessParking': "{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}", 'ByAppointmentOnly': 'False', 'BikeParking': 'True'}NaNNaNNaNNaNNaNTrueNaNFalse{'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}FalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaNzNMupayB2jEHVDOji8sxoQBeauty & Spas, BarbersMesa{'Tuesday': '8:30-17:30', 'Wednesday': '8:30-17:30', 'Thursday': '8:30-17:30', 'Friday': '8:30-17:30', 'Saturday': '7:0-15:0'}8:30-17:30NaN7:0-15:0NaN8:30-17:308:30-17:308:30-17:30133.416137-111.735743Beasley's Barber Shop85205154.5AZ
1926083735 S Las Vegas Blvd{'BikeParking': 'False', 'RestaurantsPriceRange2': '1'}NaNNaNNaNNaNNaNFalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaNc1f_VAX1KIK8-JoVhjbYOwMassage, Beauty & SpasLas Vegas{'Monday': '10:0-0:0', 'Tuesday': '10:0-0:0', 'Wednesday': '10:0-0:0', 'Thursday': '10:0-0:0', 'Friday': '10:0-0:0', 'Saturday': '10:0-0:0', 'Sunday': '10:0-0:0'}10:0-0:010:0-0:010:0-0:010:0-0:010:0-0:010:0-0:010:0-0:0036.107267-115.171920Oriental Relax8910934.0NV